﻿CREATE TABLE [dbo].[Inscripcion] (
    [IntegranteId] INT NOT NULL,
    [ActividadId]  INT NOT NULL,
    [FechaInscripcion]  DATE NOT NULL ,
	[Activa] [bit] NOT NULL,
	[FechaBaja] [date] NULL,
    CONSTRAINT [PK_Inscripcion] PRIMARY KEY CLUSTERED ([IntegranteId], [ActividadId], [FechaInscripcion]) WITH (FILLFACTOR = 80),
    CONSTRAINT [FK_Inscripcion_Actividad] FOREIGN KEY ([ActividadId]) REFERENCES [dbo].[Actividad] ([ActividadId]),
    CONSTRAINT [FK_Inscripcion_Integrante] FOREIGN KEY ([IntegranteId]) REFERENCES [dbo].[Integrante] ([IntegranteId])
);

